UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xg65o8mD2pQIZucXFSMtaKilgZittPrGqDyKhY71rNM='
WHERE
key_id = 'a3f92d34a01b54e5891afe7b6780b669c79df02725c8ad5d29f6ed0d79cea23c'
AND (
token = 'Xg65o8mD2pQIZucXFSMtaKilgZittPrGqDyKhY71rNM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)