UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mnHmcnZFRcku7Hlv92N5isYxaA2qvTzxYJrA0dFcCYw='
WHERE
key_id = '3f9c5172d6852b44b3b006385a119f3d3f4c6b4432954ccc05a008b8ce893580'
AND (
token = 'mnHmcnZFRcku7Hlv92N5isYxaA2qvTzxYJrA0dFcCYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)