UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8RMDU6mN+m+738dnNSU2DdcLDF4if2YmWAiOsdcw4Q='
WHERE
key_id = 'a24617068048d7ce02c832afb6ebb58655fc2e25b0cdd124c90393160f9821a7'
AND (
token = 'w8RMDU6mN+m+738dnNSU2DdcLDF4if2YmWAiOsdcw4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)