UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7FKry79vqtUqTbhlKxYxpi9Kb4joU6O9vPYU5AYSXK8='
WHERE
key_id = '11d9c9444c572535a8f144f13c7a2a6bd712de09973d4a86039f396768a4d021'
AND (
token = '7FKry79vqtUqTbhlKxYxpi9Kb4joU6O9vPYU5AYSXK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)