UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f1LmEAbmcBfYi/V9FeiTCMeU5x89zcqrn84MsUEjlc0='
WHERE
key_id = 'c98248dc7eba6bf2f8b205f768a6e6bdaa33e1665f835a3f86ebaa0122968ef5'
AND (
token = 'f1LmEAbmcBfYi/V9FeiTCMeU5x89zcqrn84MsUEjlc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)