UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FNiHi6E31QYaTiUjL+kwaWHbgi62Vo0Ez2N417REPw='
WHERE
key_id = '1bd385c589f623ca3b8912f32ab865c53835bf04b960868b6007d6d5ebcad1af'
AND (
token = '6FNiHi6E31QYaTiUjL+kwaWHbgi62Vo0Ez2N417REPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)