UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5YJZJX2rVO0f23NJh7he5pcxl83/cKy/d8efxxQVinw='
WHERE
key_id = 'b3f34246f355d4c64d855236d290b09e3dfa612866cefb635bb8dd55a6a1dfc8'
AND (
token = '5YJZJX2rVO0f23NJh7he5pcxl83/cKy/d8efxxQVinw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)