UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NjcKm2T0o4xoJL8Yzy3HTFxdANdKMnaY3nzhLwO5400='
WHERE
key_id = '48480d26dbd066c03dc737eff3206563d45dc6fb66a6f5c0b190d93a4c166444'
AND (
token = 'NjcKm2T0o4xoJL8Yzy3HTFxdANdKMnaY3nzhLwO5400='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)