UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KOCUdwlp8hoZTzz1IHxIiy12ghO+gZEiMPfcp7w8ucg='
WHERE
key_id = '7a5473028efb9e7a8a17d74f95aadca9a99d9b9123792f1cdad95bde7a6fb642'
AND (
token = 'KOCUdwlp8hoZTzz1IHxIiy12ghO+gZEiMPfcp7w8ucg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)