UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6J1dDbd2iwg1dfEhjOfIG9Fs9JuV9prbJ8KRHsibiE='
WHERE
key_id = 'bb3085416d47281197151b9575e2e99548454d3dc7341a485c244978a56ef493'
AND (
token = 'x6J1dDbd2iwg1dfEhjOfIG9Fs9JuV9prbJ8KRHsibiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)