UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tV8Spclalyj/ihiyO3UHoTva2Wj2JeYWnkTC6G7dApo='
WHERE
key_id = '026767b29f2da8fa317209b06e086635f5679844c45ca715118a94a3ec5f2d99'
AND (
token = 'tV8Spclalyj/ihiyO3UHoTva2Wj2JeYWnkTC6G7dApo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)