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