UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3cYQslR/6Rw9a/ElhxsZgnufMagkHQphcZLk9+Y/4r8='
WHERE
key_id = '178282bd630b3416facfd1142a89e47317396f75b9a5b2ec25451b02da4cea20'
AND (
token = '3cYQslR/6Rw9a/ElhxsZgnufMagkHQphcZLk9+Y/4r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)