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