UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AKuoBKHL01uhr+gsF7/NcgAJF9G7tAc+pbHO55OoFYg='
WHERE
key_id = 'b1bc0b004cdbb67214ad5f188e28064c213ec4bf4b9f8be60d7aed73b3ae877a'
AND (
token = 'AKuoBKHL01uhr+gsF7/NcgAJF9G7tAc+pbHO55OoFYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)