UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jSQJ8EPEWntHIaDOuVdKt1gvkBzcjVOsliASILr9rRk='
WHERE
key_id = '8fefb542a8e05116caa0ac0d47c71180142d25d1207edfb8071c8f200deb9407'
AND (
token = 'jSQJ8EPEWntHIaDOuVdKt1gvkBzcjVOsliASILr9rRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)