UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'amP/NjRjT7nhUQ/2q1aghlMXjX4EuYhoNAcDGDvGWt0='
WHERE
key_id = 'ec4f3d79a3e1094bbd9a5fb40003b7f1add26b6749e0d96b3f718019c6464046'
AND (
token = 'amP/NjRjT7nhUQ/2q1aghlMXjX4EuYhoNAcDGDvGWt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)