UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2WGKv1Dh/rzw8E0RW5tq5D8BuQRpOARK7hG0tmdpRag='
WHERE
key_id = 'a47d41de83bf24d18bcee6e744e25f1384e603e3956ea31d0e0689e692390d3d'
AND (
token = '2WGKv1Dh/rzw8E0RW5tq5D8BuQRpOARK7hG0tmdpRag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)