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