UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n+ChbFxa80EmkLAjL2+semGsWfvoQTavU5GkBD/5WgU='
WHERE
key_id = 'a74e3d5c8346b18390664245179497a6a4434f92e95366fbda2145b5739a93b6'
AND (
token = 'n+ChbFxa80EmkLAjL2+semGsWfvoQTavU5GkBD/5WgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)