UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Ra0AXyMLugUUo0qjIFSzwGzYo44rkEV3iJwDnDai2A='
WHERE
key_id = 'ce8ac3c307c2ed3ed3954195a1283bd444d1c4cb553c837f419e5ab186d8b349'
AND (
token = '1Ra0AXyMLugUUo0qjIFSzwGzYo44rkEV3iJwDnDai2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)