UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpGJhCak2/qCDfi8AmKpzH+V1zgP2QEFbGVfXA8zvcM='
WHERE
key_id = 'e907410ead9707aa941ea949119994111bc6ca6b978a6d83f9314fb054cee0ff'
AND (
token = 'zpGJhCak2/qCDfi8AmKpzH+V1zgP2QEFbGVfXA8zvcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)