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