UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7/SCtcrxBAH1Y2t4QmRavU0O6Zexn/WllGLs8FjENQ='
WHERE
key_id = 'a542d02dbc1aa2ad62d761527111e20f90555623ea6489724e20f68697e6a230'
AND (
token = 'K7/SCtcrxBAH1Y2t4QmRavU0O6Zexn/WllGLs8FjENQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)