UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4oHoLwQ2VZ6hwCqXLBs+iKl1cIPNkSpuLa0UpBGCOF4='
WHERE
key_id = '94aa245d1eb7c4e36fe06e6c584f2a2fb372ee72cfc01e668b55d6f111cc17b7'
AND (
token = '4oHoLwQ2VZ6hwCqXLBs+iKl1cIPNkSpuLa0UpBGCOF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)