UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cmd38GkhHrkp1yLnaYSjN7l+euzzgwOHtIqsgm4j0k='
WHERE
key_id = '7beb6e97229e0c9b645b6bb11f3164e1788bcf195e622dad75269641696c06ff'
AND (
token = '4cmd38GkhHrkp1yLnaYSjN7l+euzzgwOHtIqsgm4j0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)