UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCLy0auePopUi9fd0ub5hwFz7FecoCUHTPrTRxfYC9c='
WHERE
key_id = '8556b9ba6688022621e9cc576cf11078ef035d6ab05dd8e79c51b912cc67b239'
AND (
token = 'lCLy0auePopUi9fd0ub5hwFz7FecoCUHTPrTRxfYC9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)