UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7gFuHlu0VioNPJ4dlnJn/cs1S5HCDmCSbnaSppT1dw='
WHERE
key_id = 'a56c88fcfa5a296041022a83093f41fd0e0ba8ee6c0b36bc0f01b8d6a9c71167'
AND (
token = 'q7gFuHlu0VioNPJ4dlnJn/cs1S5HCDmCSbnaSppT1dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)