UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H5To287jtMmjihMl2GijBHYPmcQWHRcKrzEalVYnHo0='
WHERE
key_id = '3d9888e763cadea729c9f04255fc69e09d754a102be077e5490ab40e6cced437'
AND (
token = 'H5To287jtMmjihMl2GijBHYPmcQWHRcKrzEalVYnHo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)