UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kMgxJxCJ0stZ5I8eWi55/Bk1OEygS79DHpVuDwxlkSw='
WHERE
key_id = '1fba7860f64faf271e24533525197ae8e01a0e8a38590a19287ad10b541651a8'
AND (
token = 'kMgxJxCJ0stZ5I8eWi55/Bk1OEygS79DHpVuDwxlkSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)