UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A0M8RyDT/9tFuW5E5UZUeTGSme0AOJtJcBRxioPuTlE='
WHERE
key_id = 'bf94dec04f2b8f8d0ff2b768f2ccac598080727d051165c759aa71892186eab9'
AND (
token = 'A0M8RyDT/9tFuW5E5UZUeTGSme0AOJtJcBRxioPuTlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)